A2E · Data Dictionary
Every field, and the math behind it
The data model the suite stores, and the standard formulas it computes. Formulas are verbatim to EIA-748 (EVM) and the repo's applicability logic (flowdown). This is the reference for anyone integrating or auditing the numbers.
01
Storage & shape
A single JSON object under one browser key. The PM Platform owns writes; the Exec Deck reads it.
localStorage["a2e_pm_platform_v1"] = { project, wbs[], resources[], evm, financials, risks[], raid[], changes[], stakeholders[], closeout }
02
Project & charter
| Field | Type | Meaning |
|---|
| name | string | Project title; stamps every header. |
| customer | string | Contracting agency / customer. |
| pm | string | Project manager of record. |
| phase | enum | Initiating · Planning · Executing · Closing. |
| rag | enum | Green · Amber · Red — overall health badge. |
| baselineLocked | bool | True once the plan is frozen for variance tracking. |
| requirements[] | array | Requirements register — id, text, source, status. |
03
Scope / WBS
| Field | Type | Meaning |
|---|
| wbs[].id | string | WBS code, e.g. 1.2.3. |
| wbs[].name | string | Work package name. |
| wbs[].budget | number | Package budget. Sum of all = BAC. |
| wbs[].pctComplete | number | 0–100; feeds Earned Value. |
04
EVM fields & formulas
Inputs are PV, EV, AC and BAC. Everything else is derived, verbatim to EIA-748.
| Input | Definition |
|---|
| BAC | Budget at Completion — total baselined budget (Σ WBS budget). |
| PV | Planned Value — budgeted cost of work scheduled. |
| EV | Earned Value — budgeted cost of work performed. |
| AC | Actual Cost — cost actually incurred. |
| Derived | Formula | Reads as |
|---|
| CPI | EV / AC | Cost efficiency; <1 = over budget. |
| SPI | EV / PV | Schedule efficiency; <1 = behind. |
| CV | EV − AC | Cost variance in dollars. |
| SV | EV − PV | Schedule variance in dollars. |
| EAC | BAC / CPI | Forecast cost at completion. |
| ETC | EAC − AC | Estimate to complete. |
| VAC | BAC − EAC | Variance at completion. |
| TCPI | (BAC − EV)/(BAC − AC) | Efficiency needed to finish on budget. |
05
Financials & rates
| Field / rule | Formula | Meaning |
|---|
| loadedCost | rawCost × 1.35 | Default wrap on raw labor cost. |
| margin | (Bill − Cost) / Bill | Gross margin on billing. |
| HOURS{role} | map | Planned hours per role, keyed by role name. |
| resources[].rate | number | Billing rate per role/person. |
06
Risk & RAID
| Field / rule | Formula | Meaning |
|---|
| risks[].probability | 0–1 | Likelihood of the risk event. |
| risks[].costImpact | number | Dollar impact if it occurs. |
| EMV | probability × costImpact | Expected Monetary Value per risk. |
| contingency | default 3% × TCV | Reserve; compared against Σ EMV for a verdict. |
| raid[].type | enum | Risk · Assumption · Issue · Dependency. |
07
Subcontract & flowdown
| Field | Type | Meaning |
|---|
| sub.contractType | enum | FFP · CPFF · CPFF-Comm · T&M, etc. |
| sub.value / ceiling | number | Awarded value and ceiling. |
| sub.funded / spent | number | Drives the Limit-of-Funds burn alert. |
| sub.samStatus | enum | SAM.gov exclusion check — Clear / Flagged. |
| sub.cmmc | int | CMMC maturity level. |
| clause.applies | bool | AND-semantics over contract type + dollar thresholds; excludes time_and_materials from cost-type set. |
40 clauses copied verbatim from clause_library.json; applicability is a faithful JS port of applicability.py. No clause prose stored — rows link to eCFR Title 48.
08
Capture economics
| Field | Formula | Meaning |
|---|
| TCV | input | Total contract value of the opportunity. |
| pwin | 0–100% | Probability of win. |
| expectedValue | TCV × pwin | Risk-weighted value of pursuing. |
| grossProfit | TCV × margin | Profit at target margin. |
| bpShare | B&P / TCV | Bid & proposal spend as % of TCV. |
| riskEMV | input | Expected monetary value of pursuit risk. |
| recommendation | enum | Bid / No-bid, derived from the above. |